My Data

Overview
Reproduction

Dataset statistics

Number of variables	17
Number of observations	52924
Missing cells	400
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	6.9 MiB
Average record size in memory	136.0 B

Variable types

Text	3
DateTime	1
Categorical	7
Numeric	6

Reproduction

Analysis started	2024-02-25 22:59:50.886098
Analysis finished	2024-02-25 22:59:59.139859
Duration	8.25 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

고객ID
Text

Distinct	1468
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Memory size	413.6 KiB

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	476316
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	66 ?
Unique (%)	0.1%

Sample

1st row	USER_1358
2nd row	USER_1358
3rd row	USER_1358
4th row	USER_1358
5th row	USER_1358

Value	Count	Frequency (%)
user_0118	695	1.3%
user_0736	587	1.1%
user_0563	575	1.1%
user_1355	572	1.1%
user_0643	523	1.0%
user_0202	366	0.7%
user_0667	315	0.6%
user_1358	297	0.6%
user_0572	290	0.5%
user_0200	261	0.5%
Other values (1458)	48443	91.5%

Most occurring characters

Value	Count	Frequency (%)
U	52924	11.1%
S	52924	11.1%
E	52924	11.1%
R	52924	11.1%
_	52924	11.1%
0	52729	11.1%
1	33865	7.1%
3	18402	3.9%
2	18079	3.8%
4	16238	3.4%
Other values (5)	72383	15.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	211696	44.4%
Decimal Number	211696	44.4%
Connector Punctuation	52924	11.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	52729	24.9%
1	33865	16.0%
3	18402	8.7%
2	18079	8.5%
4	16238	7.7%
5	15809	7.5%
6	15082	7.1%
8	14715	7.0%
7	13637	6.4%
9	13140	6.2%

Uppercase Letter

Value	Count	Frequency (%)
U	52924	25.0%
S	52924	25.0%
E	52924	25.0%
R	52924	25.0%

Connector Punctuation

Value	Count	Frequency (%)
_	52924	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	264620	55.6%
Latin	211696	44.4%

Most frequent character per script

Common

Value	Count	Frequency (%)
_	52924	20.0%
0	52729	19.9%
1	33865	12.8%
3	18402	7.0%
2	18079	6.8%
4	16238	6.1%
5	15809	6.0%
6	15082	5.7%
8	14715	5.6%
7	13637	5.2%

Latin

Value	Count	Frequency (%)
U	52924	25.0%
S	52924	25.0%
E	52924	25.0%
R	52924	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	476316	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
U	52924	11.1%
S	52924	11.1%
E	52924	11.1%
R	52924	11.1%
_	52924	11.1%
0	52729	11.1%
1	33865	7.1%
3	18402	3.9%
2	18079	3.8%
4	16238	3.4%
Other values (5)	72383	15.2%

거래ID
Text

Distinct	25061
Distinct (%)	47.4%
Missing	0
Missing (%)	0.0%
Memory size	413.6 KiB

Length

Max length	17
Median length	17
Mean length	16.597895
Min length	16

Characters and Unicode

Total characters	878427
Distinct characters	20
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14637 ?
Unique (%)	27.7%

Sample

1st row	Transaction_0000
2nd row	Transaction_0001
3rd row	Transaction_0002
4th row	Transaction_0003
5th row	Transaction_0003

Value	Count	Frequency (%)
transaction_12261	35	0.1%
transaction_4716	30	0.1%
transaction_19047	29	0.1%
transaction_13487	28	0.1%
transaction_16759	27	0.1%
transaction_6767	26	< 0.1%
transaction_19791	26	< 0.1%
transaction_5941	24	< 0.1%
transaction_17903	23	< 0.1%
transaction_13065	23	< 0.1%
Other values (25051)	52653	99.5%

Most occurring characters

Value	Count	Frequency (%)
a	105848	12.0%
n	105848	12.0%
T	52924	6.0%
r	52924	6.0%
s	52924	6.0%
c	52924	6.0%
t	52924	6.0%
i	52924	6.0%
o	52924	6.0%
_	52924	6.0%
Other values (10)	243339	27.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	529240	60.2%
Decimal Number	243339	27.7%
Uppercase Letter	52924	6.0%
Connector Punctuation	52924	6.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	44323	18.2%
2	31054	12.8%
4	22242	9.1%
3	22174	9.1%
0	21910	9.0%
5	20568	8.5%
6	20543	8.4%
7	20190	8.3%
8	20174	8.3%
9	20161	8.3%

Lowercase Letter

Value	Count	Frequency (%)
a	105848	20.0%
n	105848	20.0%
r	52924	10.0%
s	52924	10.0%
c	52924	10.0%
t	52924	10.0%
i	52924	10.0%
o	52924	10.0%

Uppercase Letter

Value	Count	Frequency (%)
T	52924	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	52924	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	582164	66.3%
Common	296263	33.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
_	52924	17.9%
1	44323	15.0%
2	31054	10.5%
4	22242	7.5%
3	22174	7.5%
0	21910	7.4%
5	20568	6.9%
6	20543	6.9%
7	20190	6.8%
8	20174	6.8%

Latin

Value	Count	Frequency (%)
a	105848	18.2%
n	105848	18.2%
T	52924	9.1%
r	52924	9.1%
s	52924	9.1%
c	52924	9.1%
t	52924	9.1%
i	52924	9.1%
o	52924	9.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	878427	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	105848	12.0%
n	105848	12.0%
T	52924	6.0%
r	52924	6.0%
s	52924	6.0%
c	52924	6.0%
t	52924	6.0%
i	52924	6.0%
o	52924	6.0%
_	52924	6.0%
Other values (10)	243339	27.7%

거래날짜
Date

Distinct	365
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	413.6 KiB

Minimum	2019-01-01 00:00:00
Maximum	2019-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

제품ID
Text

Distinct	1145
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Memory size	413.6 KiB

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	635088
Distinct characters	18
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	90 ?
Unique (%)	0.2%

Sample

1st row	Product_0981
2nd row	Product_0981
3rd row	Product_0904
4th row	Product_0203
5th row	Product_0848

Value	Count	Frequency (%)
product_0981	3511	6.6%
product_0983	3328	6.3%
product_0976	3230	6.1%
product_0984	1361	2.6%
product_0989	1089	2.1%
product_0985	1065	2.0%
product_0992	844	1.6%
product_0904	806	1.5%
product_0990	599	1.1%
product_0880	583	1.1%
Other values (1135)	36508	69.0%

Most occurring characters

Value	Count	Frequency (%)
0	62552	9.8%
P	52924	8.3%
r	52924	8.3%
o	52924	8.3%
d	52924	8.3%
u	52924	8.3%
c	52924	8.3%
t	52924	8.3%
_	52924	8.3%
9	36945	5.8%
Other values (8)	112199	17.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	317544	50.0%
Decimal Number	211696	33.3%
Uppercase Letter	52924	8.3%
Connector Punctuation	52924	8.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	62552	29.5%
9	36945	17.5%
8	23570	11.1%
1	17721	8.4%
4	13315	6.3%
2	13135	6.2%
3	12135	5.7%
6	11047	5.2%
7	10872	5.1%
5	10404	4.9%

Lowercase Letter

Value	Count	Frequency (%)
r	52924	16.7%
o	52924	16.7%
d	52924	16.7%
u	52924	16.7%
c	52924	16.7%
t	52924	16.7%

Uppercase Letter

Value	Count	Frequency (%)
P	52924	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	52924	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	370468	58.3%
Common	264620	41.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	62552	23.6%
_	52924	20.0%
9	36945	14.0%
8	23570	8.9%
1	17721	6.7%
4	13315	5.0%
2	13135	5.0%
3	12135	4.6%
6	11047	4.2%
7	10872	4.1%

Latin

Value	Count	Frequency (%)
P	52924	14.3%
r	52924	14.3%
o	52924	14.3%
d	52924	14.3%
u	52924	14.3%
c	52924	14.3%
t	52924	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	635088	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	62552	9.8%
P	52924	8.3%
r	52924	8.3%
o	52924	8.3%
d	52924	8.3%
u	52924	8.3%
c	52924	8.3%
t	52924	8.3%
_	52924	8.3%
9	36945	5.8%
Other values (8)	112199	17.7%

제품카테고리
Categorical

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	413.6 KiB

Apparel	18126
Nest-USA	14013
Office	6513
Drinkware	3483
Lifestyle	3092
Other values (15)	7697

Length

Max length	20
Median length	11
Mean length	7.3746504
Min length	3

Characters and Unicode

Total characters	390296
Distinct characters	38
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Nest-USA
2nd row	Nest-USA
3rd row	Office
4th row	Apparel
5th row	Bags

Common Values

Value	Count	Frequency (%)
Apparel	18126	34.2%
Nest-USA	14013	26.5%
Office	6513	12.3%
Drinkware	3483	6.6%
Lifestyle	3092	5.8%
Nest	2198	4.2%
Bags	1882	3.6%
Headgear	771	1.5%
Notebooks & Journals	749	1.4%
Waze	554	1.0%
Other values (10)	1543	2.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
apparel	18126	33.2%
nest-usa	14013	25.7%
office	6513	11.9%
drinkware	3483	6.4%
lifestyle	3092	5.7%
nest	2198	4.0%
bags	1928	3.5%
headgear	771	1.4%
notebooks	749	1.4%
	749	1.4%
Other values (13)	3005	5.5%

Most occurring characters

Value	Count	Frequency (%)
e	54810	14.0%
p	36341	9.3%
A	32416	8.3%
a	27792	7.1%
r	27216	7.0%
s	24508	6.3%
l	22340	5.7%
t	21064	5.4%
N	17277	4.4%
f	16277	4.2%
Other values (28)	110255	28.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	277280	71.0%
Uppercase Letter	96234	24.7%
Dash Punctuation	14330	3.7%
Space Separator	1703	0.4%
Other Punctuation	749	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	54810	19.8%
p	36341	13.1%
a	27792	10.0%
r	27216	9.8%
s	24508	8.8%
l	22340	8.1%
t	21064	7.6%
f	16277	5.9%
i	13524	4.9%
c	7159	2.6%
Other values (10)	26249	9.5%

Uppercase Letter

Value	Count	Frequency (%)
A	32416	33.7%
N	17277	18.0%
S	14013	14.6%
U	14013	14.6%
O	6513	6.8%
D	3483	3.6%
L	3092	3.2%
B	2285	2.4%
H	893	0.9%
J	749	0.8%
Other values (5)	1500	1.6%

Dash Punctuation

Value	Count	Frequency (%)
-	14330	100.0%

Space Separator

Value	Count	Frequency (%)
	1703	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	749	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	373514	95.7%
Common	16782	4.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	54810	14.7%
p	36341	9.7%
A	32416	8.7%
a	27792	7.4%
r	27216	7.3%
s	24508	6.6%
l	22340	6.0%
t	21064	5.6%
N	17277	4.6%
f	16277	4.4%
Other values (25)	93473	25.0%

Common

Value	Count	Frequency (%)
-	14330	85.4%
	1703	10.1%
&	749	4.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	390296	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	54810	14.0%
p	36341	9.3%
A	32416	8.3%
a	27792	7.1%
r	27216	7.0%
s	24508	6.3%
l	22340	5.7%
t	21064	5.4%
N	17277	4.4%
f	16277	4.2%
Other values (28)	110255	28.2%

수량
Real number (ℝ)

Distinct	151
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.4976381

Minimum	1
Maximum	900
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	413.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	16
Maximum	900
Range	899
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	20.104711
Coefficient of variation (CV)	4.4700597
Kurtosis	525.45248
Mean	4.4976381
Median Absolute Deviation (MAD)	0
Skewness	19.034802
Sum	238033
Variance	404.1994
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	35336	66.8%
2	7016	13.3%
3	2288	4.3%
5	1734	3.3%
4	1237	2.3%
10	1035	2.0%
20	531	1.0%
6	435	0.8%
15	389	0.7%
25	287	0.5%
Other values (141)	2636	5.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	35336	66.8%
2	7016	13.3%
3	2288	4.3%
4	1237	2.3%
5	1734	3.3%
6	435	0.8%
7	180	0.3%
8	240	0.5%
9	57	0.1%
10	1035	2.0%

Value	Count	Frequency (%)
900	1	< 0.1%
825	2	< 0.1%
791	1	< 0.1%
750	1	< 0.1%
600	5	< 0.1%
563	1	< 0.1%
523	1	< 0.1%
516	1	< 0.1%
500	12	< 0.1%
475	3	< 0.1%

평균금액
Real number (ℝ)

Distinct	546
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.237646

Minimum	0.39
Maximum	355.74
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	413.6 KiB

Quantile statistics

Minimum	0.39
5-th percentile	1.99
Q1	5.7
median	16.99
Q3	102.13
95-th percentile	151.88
Maximum	355.74
Range	355.35
Interquartile range (IQR)	96.43

Descriptive statistics

Standard deviation	64.006882
Coefficient of variation (CV)	1.2253018
Kurtosis	3.3424017
Mean	52.237646
Median Absolute Deviation (MAD)	14.19
Skewness	1.6325798
Sum	2764625.2
Variance	4096.8809
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
119	5127	9.7%
149	3824	7.2%
79	1937	3.7%
13.59	1530	2.9%
2.39	1284	2.4%
2.99	1226	2.3%
16.99	1036	2.0%
15.19	984	1.9%
1.99	956	1.8%
3.99	949	1.8%
Other values (536)	34071	64.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.39	1	< 0.1%
0.4	45	0.1%
0.41	15	< 0.1%
0.5	33	0.1%
0.51	27	0.1%
0.79	164	0.3%
0.8	14	< 0.1%
0.81	21	< 0.1%
0.97	1	< 0.1%
0.98	16	< 0.1%

Value	Count	Frequency (%)
355.74	169	0.3%
349	330	0.6%
279	147	0.3%
274.19	3	< 0.1%
269	1	< 0.1%
256.88	7	< 0.1%
254.82	1	< 0.1%
250	44	0.1%
249	26	< 0.1%
205.3	33	0.1%

배송료
Real number (ℝ)

Distinct	267
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.51763

Minimum	0
Maximum	521.36
Zeros	162
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	413.6 KiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	6
median	6
Q3	6.5
95-th percentile	26.43
Maximum	521.36
Range	521.36
Interquartile range (IQR)	0.5

Descriptive statistics

Standard deviation	19.475613
Coefficient of variation (CV)	1.8517111
Kurtosis	204.63769
Mean	10.51763
Median Absolute Deviation (MAD)	0
Skewness	11.959739
Sum	556635.07
Variance	379.29951
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	26801	50.6%
6.5	15819	29.9%
12.99	2532	4.8%
19.99	1042	2.0%
12.48	798	1.5%
12.91	454	0.9%
8.7	325	0.6%
0	162	0.3%
18.47	139	0.3%
13.38	111	0.2%
Other values (257)	4741	9.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	162	0.3%
6	26801	50.6%
6.46	14	< 0.1%
6.48	29	0.1%
6.5	15819	29.9%
6.51	18	< 0.1%
8.36	4	< 0.1%
8.7	325	0.6%
8.91	7	< 0.1%
11.1	17	< 0.1%

Value	Count	Frequency (%)
521.36	1	< 0.1%
504	2	< 0.1%
492.84	10	< 0.1%
422.24	4	< 0.1%
354	3	< 0.1%
351.64	2	< 0.1%
344.78	5	< 0.1%
324	29	0.1%
323.47	7	< 0.1%
307.47	1	< 0.1%

쿠폰상태
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	413.6 KiB

Clicked	26926
Used	17904
Not Used	8094

Length

Max length	8
Median length	7
Mean length	6.138047
Min length	4

Characters and Unicode

Total characters	324850
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Used
2nd row	Used
3rd row	Used
4th row	Not Used
5th row	Used

Common Values

Value	Count	Frequency (%)
Clicked	26926	50.9%
Used	17904	33.8%
Not Used	8094	15.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
clicked	26926	44.1%
used	25998	42.6%
not	8094	13.3%

Most occurring characters

Value	Count	Frequency (%)
e	52924	16.3%
d	52924	16.3%
C	26926	8.3%
l	26926	8.3%
i	26926	8.3%
c	26926	8.3%
k	26926	8.3%
U	25998	8.0%
s	25998	8.0%
N	8094	2.5%
Other values (3)	24282	7.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	255738	78.7%
Uppercase Letter	61018	18.8%
Space Separator	8094	2.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	52924	20.7%
d	52924	20.7%
l	26926	10.5%
i	26926	10.5%
c	26926	10.5%
k	26926	10.5%
s	25998	10.2%
o	8094	3.2%
t	8094	3.2%

Uppercase Letter

Value	Count	Frequency (%)
C	26926	44.1%
U	25998	42.6%
N	8094	13.3%

Space Separator

Value	Count	Frequency (%)
	8094	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	316756	97.5%
Common	8094	2.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	52924	16.7%
d	52924	16.7%
C	26926	8.5%
l	26926	8.5%
i	26926	8.5%
c	26926	8.5%
k	26926	8.5%
U	25998	8.2%
s	25998	8.2%
N	8094	2.6%
Other values (2)	16188	5.1%

Common

Value	Count	Frequency (%)
	8094	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	324850	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	52924	16.3%
d	52924	16.3%
C	26926	8.3%
l	26926	8.3%
i	26926	8.3%
c	26926	8.3%
k	26926	8.3%
U	25998	8.0%
s	25998	8.0%
N	8094	2.5%
Other values (3)	24282	7.5%

성별
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	413.6 KiB

여	33007
남	19917

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	52924
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	남
2nd row	남
3rd row	남
4th row	남
5th row	남

Common Values

Value	Count	Frequency (%)
여	33007	62.4%
남	19917	37.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
여	33007	62.4%
남	19917	37.6%

Most occurring characters

Value	Count	Frequency (%)
여	33007	62.4%
남	19917	37.6%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	52924	100.0%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
여	33007	62.4%
남	19917	37.6%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	52924	100.0%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
여	33007	62.4%
남	19917	37.6%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	52924	100.0%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
여	33007	62.4%
남	19917	37.6%

고객지역
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	413.6 KiB

Chicago	18380
California	16136
New York	11173
New Jersey	4503
Washington DC	2732

Length

Max length	13
Median length	10
Mean length	8.6907641
Min length	7

Characters and Unicode

Total characters	459950
Distinct characters	23
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Chicago
2nd row	Chicago
3rd row	Chicago
4th row	Chicago
5th row	Chicago

Common Values

Value	Count	Frequency (%)
Chicago	18380	34.7%
California	16136	30.5%
New York	11173	21.1%
New Jersey	4503	8.5%
Washington DC	2732	5.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
chicago	18380	25.8%
california	16136	22.6%
new	15676	22.0%
york	11173	15.7%
jersey	4503	6.3%
washington	2732	3.8%
dc	2732	3.8%

Most occurring characters

Value	Count	Frequency (%)
i	53384	11.6%
a	53384	11.6%
o	48421	10.5%
C	37248	8.1%
r	31812	6.9%
e	24682	5.4%
n	21600	4.7%
g	21112	4.6%
h	21112	4.6%
	18408	4.0%
Other values (13)	128787	28.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	367478	79.9%
Uppercase Letter	74064	16.1%
Space Separator	18408	4.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	53384	14.5%
a	53384	14.5%
o	48421	13.2%
r	31812	8.7%
e	24682	6.7%
n	21600	5.9%
g	21112	5.7%
h	21112	5.7%
c	18380	5.0%
l	16136	4.4%
Other values (6)	57455	15.6%

Uppercase Letter

Value	Count	Frequency (%)
C	37248	50.3%
N	15676	21.2%
Y	11173	15.1%
J	4503	6.1%
W	2732	3.7%
D	2732	3.7%

Space Separator

Value	Count	Frequency (%)
	18408	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	441542	96.0%
Common	18408	4.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	53384	12.1%
a	53384	12.1%
o	48421	11.0%
C	37248	8.4%
r	31812	7.2%
e	24682	5.6%
n	21600	4.9%
g	21112	4.8%
h	21112	4.8%
c	18380	4.2%
Other values (12)	110407	25.0%

Common

Value	Count	Frequency (%)
	18408	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	459950	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	53384	11.6%
a	53384	11.6%
o	48421	10.5%
C	37248	8.1%
r	31812	6.9%
e	24682	5.4%
n	21600	4.7%
g	21112	4.6%
h	21112	4.6%
	18408	4.0%
Other values (13)	128787	28.0%

가입기간
Real number (ℝ)

Distinct	49
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26.127995

Minimum	2
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	413.6 KiB

Quantile statistics

Minimum	2
5-th percentile	5
Q1	15
median	27
Q3	37
95-th percentile	47
Maximum	50
Range	48
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	13.478285
Coefficient of variation (CV)	0.51585609
Kurtosis	-1.1171716
Mean	26.127995
Median Absolute Deviation (MAD)	11
Skewness	-0.06955528
Sum	1382798
Variance	181.66417
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
40	2043	3.9%
25	1853	3.5%
34	1670	3.2%
30	1656	3.1%
33	1648	3.1%
21	1590	3.0%
5	1543	2.9%
45	1469	2.8%
10	1448	2.7%
28	1417	2.7%
Other values (39)	36587	69.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	649	1.2%
3	625	1.2%
4	1055	2.0%
5	1543	2.9%
6	1296	2.4%
7	985	1.9%
8	1202	2.3%
9	626	1.2%
10	1448	2.7%
11	902	1.7%

Value	Count	Frequency (%)
50	737	1.4%
49	841	1.6%
48	884	1.7%
47	497	0.9%
46	756	1.4%
45	1469	2.8%
44	1223	2.3%
43	889	1.7%
42	755	1.4%
41	985	1.9%

오프라인비용
Real number (ℝ)

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2830.9141

Minimum	500
Maximum	5000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	413.6 KiB

Quantile statistics

Minimum	500
5-th percentile	1000
Q1	2500
median	3000
Q3	3500
95-th percentile	4500
Maximum	5000
Range	4500
Interquartile range (IQR)	1000

Descriptive statistics

Standard deviation	936.15425
Coefficient of variation (CV)	0.33068973
Kurtosis	0.10199859
Mean	2830.9141
Median Absolute Deviation (MAD)	500
Skewness	-0.31680745
Sum	1.498233 × 10⁸
Variance	876384.77
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
3000	13529	25.6%
2500	10333	19.5%
3500	9008	17.0%
2000	6019	11.4%
4000	4882	9.2%
1500	2411	4.6%
4500	2115	4.0%
1000	1840	3.5%
500	985	1.9%
700	969	1.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
500	985	1.9%
700	969	1.8%
1000	1840	3.5%
1500	2411	4.6%
2000	6019	11.4%
2500	10333	19.5%
3000	13529	25.6%
3500	9008	17.0%
4000	4882	9.2%
4500	2115	4.0%

Value	Count	Frequency (%)
5000	833	1.6%
4500	2115	4.0%
4000	4882	9.2%
3500	9008	17.0%
3000	13529	25.6%
2500	10333	19.5%
2000	6019	11.4%
1500	2411	4.6%
1000	1840	3.5%
700	969	1.8%

온라인비용
Real number (ℝ)

Distinct	365
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1893.1091

Minimum	320.25
Maximum	4556.93
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	413.6 KiB

Quantile statistics

Minimum	320.25
5-th percentile	682.42
Q1	1252.63
median	1837.87
Q3	2425.35
95-th percentile	3396.14
Maximum	4556.93
Range	4236.68
Interquartile range (IQR)	1172.72

Descriptive statistics

Standard deviation	807.01409
Coefficient of variation (CV)	0.42629032
Kurtosis	-0.14764686
Mean	1893.1091
Median Absolute Deviation (MAD)	587.1
Skewness	0.45430588
Sum	1.0019091 × 10⁸
Variance	651271.74
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2819.58	335	0.6%
2489.36	311	0.6%
1692.8	298	0.6%
2155.96	292	0.6%
985.28	291	0.5%
2563.83	289	0.5%
1292.58	278	0.5%
663.46	274	0.5%
1331.1	269	0.5%
1172.96	264	0.5%
Other values (355)	50023	94.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
320.25	130	0.2%
417.73	185	0.3%
465.4	43	0.1%
478.27	131	0.2%
484.9	160	0.3%
515.44	118	0.2%
526.96	96	0.2%
560.02	140	0.3%
620.94	135	0.3%
640.93	56	0.1%

Value	Count	Frequency (%)
4556.93	141	0.3%
4349.02	124	0.2%
4055.3	189	0.4%
4019.93	61	0.1%
3897.2	129	0.2%
3875.08	163	0.3%
3796.85	159	0.3%
3784.07	133	0.3%
3749.46	35	0.1%
3727.61	117	0.2%

GST
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	413.6 KiB

0.18	27343
0.1	21314
0.05	4145
0.12	122

Length

Max length	4
Median length	4
Mean length	3.5972716
Min length	3

Characters and Unicode

Total characters	190382
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.1
2nd row	0.1
3rd row	0.1
4th row	0.18
5th row	0.18

Common Values

Value	Count	Frequency (%)
0.18	27343	51.7%
0.1	21314	40.3%
0.05	4145	7.8%
0.12	122	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.18	27343	51.7%
0.1	21314	40.3%
0.05	4145	7.8%
0.12	122	0.2%

Most occurring characters

Value	Count	Frequency (%)
0	57069	30.0%
.	52924	27.8%
1	48779	25.6%
8	27343	14.4%
5	4145	2.2%
2	122	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	137458	72.2%
Other Punctuation	52924	27.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	57069	41.5%
1	48779	35.5%
8	27343	19.9%
5	4145	3.0%
2	122	0.1%

Other Punctuation

Value	Count	Frequency (%)
.	52924	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	190382	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	57069	30.0%
.	52924	27.8%
1	48779	25.6%
8	27343	14.4%
5	4145	2.2%
2	122	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	190382	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	57069	30.0%
.	52924	27.8%
1	48779	25.6%
8	27343	14.4%
5	4145	2.2%
2	122	0.1%

쿠폰코드
Categorical

Distinct	45
Distinct (%)	0.1%
Missing	400
Missing (%)	0.8%
Memory size	413.6 KiB

SALE20	6373
SALE30	5915
SALE10	5838
ELEC10	4826
ELEC30	4647
Other values (40)	24925

Length

Max length	7
Median length	6
Mean length	5.8379217
Min length	4

Characters and Unicode

Total characters	306631
Distinct characters	25
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ELEC10
2nd row	ELEC10
3rd row	OFF10
4th row	SALE10
5th row	AIO10

Common Values

Value	Count	Frequency (%)
SALE20	6373	12.0%
SALE30	5915	11.2%
SALE10	5838	11.0%
ELEC10	4826	9.1%
ELEC30	4647	8.8%
ELEC20	4540	8.6%
EXTRA10	2317	4.4%
OFF10	2250	4.3%
EXTRA20	2211	4.2%
OFF20	2202	4.2%
Other values (35)	11405	21.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sale20	6373	12.1%
sale30	5915	11.3%
sale10	5838	11.1%
elec10	4826	9.2%
elec30	4647	8.8%
elec20	4540	8.6%
extra10	2317	4.4%
off10	2250	4.3%
extra20	2211	4.2%
off20	2202	4.2%
Other values (35)	11405	21.7%

Most occurring characters

Value	Count	Frequency (%)
E	56250	18.3%
0	52524	17.1%
L	32139	10.5%
A	27948	9.1%
S	18126	5.9%
2	17830	5.8%
1	17470	5.7%
3	17224	5.6%
C	14957	4.9%
F	13026	4.2%
Other values (15)	39137	12.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	201583	65.7%
Decimal Number	105048	34.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	56250	27.9%
L	32139	15.9%
A	27948	13.9%
S	18126	9.0%
C	14957	7.4%
F	13026	6.5%
O	8517	4.2%
R	7346	3.6%
T	6843	3.4%
X	6575	3.3%
Other values (11)	9856	4.9%

Decimal Number

Value	Count	Frequency (%)
0	52524	50.0%
2	17830	17.0%
1	17470	16.6%
3	17224	16.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	201583	65.7%
Common	105048	34.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	56250	27.9%
L	32139	15.9%
A	27948	13.9%
S	18126	9.0%
C	14957	7.4%
F	13026	6.5%
O	8517	4.2%
R	7346	3.6%
T	6843	3.4%
X	6575	3.3%
Other values (11)	9856	4.9%

Common

Value	Count	Frequency (%)
0	52524	50.0%
2	17830	17.0%
1	17470	16.6%
3	17224	16.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	306631	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	56250	18.3%
0	52524	17.1%
L	32139	10.5%
A	27948	9.1%
S	18126	5.9%
2	17830	5.8%
1	17470	5.7%
3	17224	5.6%
C	14957	4.9%
F	13026	4.2%
Other values (15)	39137	12.8%

할인율
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	413.6 KiB

20.0	17830
10.0	17470
30.0	17224
0.0	400

Length

Max length	4
Median length	4
Mean length	3.992442
Min length	3

Characters and Unicode

Total characters	211296
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	10.0
2nd row	10.0
3rd row	10.0
4th row	10.0
5th row	10.0

Common Values

Value	Count	Frequency (%)
20.0	17830	33.7%
10.0	17470	33.0%
30.0	17224	32.5%
0.0	400	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
20.0	17830	33.7%
10.0	17470	33.0%
30.0	17224	32.5%
0.0	400	0.8%

Most occurring characters

Value	Count	Frequency (%)
0	105848	50.1%
.	52924	25.0%
2	17830	8.4%
1	17470	8.3%
3	17224	8.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	158372	75.0%
Other Punctuation	52924	25.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	105848	66.8%
2	17830	11.3%
1	17470	11.0%
3	17224	10.9%

Other Punctuation

Value	Count	Frequency (%)
.	52924	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	211296	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	105848	50.1%
.	52924	25.0%
2	17830	8.4%
1	17470	8.3%
3	17224	8.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	211296	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	105848	50.1%
.	52924	25.0%
2	17830	8.4%
1	17470	8.3%
3	17224	8.2%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	고객ID	거래ID	거래날짜	제품ID	제품카테고리	수량	평균금액	배송료	쿠폰상태	성별	고객지역	가입기간	오프라인비용	온라인비용	GST	쿠폰코드	할인율
0	USER_1358	Transaction_0000	2019-01-01	Product_0981	Nest-USA	1	153.71	6.5	Used	남	Chicago	12	4500	2424.5	0.10	ELEC10	10.0
1	USER_1358	Transaction_0001	2019-01-01	Product_0981	Nest-USA	1	153.71	6.5	Used	남	Chicago	12	4500	2424.5	0.10	ELEC10	10.0
2	USER_1358	Transaction_0002	2019-01-01	Product_0904	Office	1	2.05	6.5	Used	남	Chicago	12	4500	2424.5	0.10	OFF10	10.0
3	USER_1358	Transaction_0003	2019-01-01	Product_0203	Apparel	5	17.53	6.5	Not Used	남	Chicago	12	4500	2424.5	0.18	SALE10	10.0
4	USER_1358	Transaction_0003	2019-01-01	Product_0848	Bags	1	16.50	6.5	Used	남	Chicago	12	4500	2424.5	0.18	AIO10	10.0
5	USER_1358	Transaction_0003	2019-01-01	Product_0854	Bags	15	5.15	6.5	Used	남	Chicago	12	4500	2424.5	0.18	AIO10	10.0
6	USER_1358	Transaction_0003	2019-01-01	Product_0880	Drinkware	15	3.08	6.5	Not Used	남	Chicago	12	4500	2424.5	0.18	EXTRA10	10.0
7	USER_1358	Transaction_0003	2019-01-01	Product_0885	Drinkware	15	10.31	6.5	Clicked	남	Chicago	12	4500	2424.5	0.18	EXTRA10	10.0
8	USER_1358	Transaction_0003	2019-01-01	Product_0898	Drinkware	5	9.27	6.5	Used	남	Chicago	12	4500	2424.5	0.18	EXTRA10	10.0
9	USER_0190	Transaction_0003	2019-01-01	Product_0914	Office	52	0.98	6.5	Used	남	California	43	4500	2424.5	0.10	OFF10	10.0

	고객ID	거래ID	거래날짜	제품ID	제품카테고리	수량	평균금액	배송료	쿠폰상태	성별	고객지역	가입기간	오프라인비용	온라인비용	GST	쿠폰코드	할인율
52914	USER_0504	Transaction_25053	2019-12-31	Product_0992	Nest	1	100.91	6.50	Clicked	여	New York	45	4000	2058.75	0.05	NE30	30.0
52915	USER_0504	Transaction_25054	2019-12-31	Product_0976	Nest-USA	1	121.30	6.50	Not Used	여	New York	45	4000	2058.75	0.10	ELEC30	30.0
52916	USER_0504	Transaction_25054	2019-12-31	Product_0984	Nest-USA	2	80.52	6.50	Clicked	여	New York	45	4000	2058.75	0.10	ELEC30	30.0
52917	USER_0504	Transaction_25054	2019-12-31	Product_0992	Nest	1	100.91	6.50	Clicked	여	New York	45	4000	2058.75	0.05	NE30	30.0
52918	USER_0504	Transaction_25055	2019-12-31	Product_0992	Nest	3	100.91	6.50	Clicked	여	New York	45	4000	2058.75	0.05	NE30	30.0
52919	USER_0504	Transaction_25056	2019-12-31	Product_0976	Nest-USA	1	121.30	6.50	Clicked	여	New York	45	4000	2058.75	0.10	ELEC30	30.0
52920	USER_0504	Transaction_25057	2019-12-31	Product_0413	Apparel	1	48.92	6.50	Used	여	New York	45	4000	2058.75	0.18	SALE30	30.0
52921	USER_0504	Transaction_25058	2019-12-31	Product_0989	Nest-USA	1	151.88	6.50	Used	여	New York	45	4000	2058.75	0.10	ELEC30	30.0
52922	USER_0562	Transaction_25059	2019-12-31	Product_0985	Nest-USA	5	80.52	6.50	Clicked	여	California	7	4000	2058.75	0.10	ELEC30	30.0
52923	USER_0562	Transaction_25060	2019-12-31	Product_0984	Nest-USA	4	80.52	19.99	Clicked	여	California	7	4000	2058.75	0.10	ELEC30	30.0

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Uppercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Uppercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Dash Punctuation

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters